The breakdown functionality makes it easier to break down the budget to the lowest unit possible. This lets you insert a budget at a high level (for example, a monthly level instead of daily) and break it down later for ease of use.
There are four breakdown options available in the Retail Sales Budget page:
- Breakdown to Days
- This will break down budgets that are not in Period Type Day (that is Year, Quarter, Month, or Week) to Day. The amount and quantity in the initial budget entry will be evenly distributed to the new entries, to each day in the year, quarter, month, or week.
- Breakdown to Items
- This will break down budgets that are not in Budget Type Item and Item Hierarchy (that is Division, Item Category, or Product Group) to Item. The amount and quantity in the initial budget entry will be evenly distributed to the new entries, to each item that belongs to the division, item category, or product group.
- Breakdown to Stores (Allocation Rule)
- This will break down budget entries without Store No. according to the Allocation Rule Code setup. The amount and quantity in the initial budget entry will be distributed to the new entries based on the weights and share % as per setup for each store in the Allocation Rule. This action will automatically activate the Budget per Store setup and assign the relevant stores to the budget.
- Breakdown to Stores (Distribution)
- This will break down budget entries without Store No. according to the Store Distribution setup that have been assigned to each item or item group in the budget. The amount and quantity in the initial budget entry will be distributed to the new entries based on the calculation settings in the Store Distribution Rule. You will need to activate Budget per Store and assign stores to the budget before using this function.
- For more information on how the Store Distribution Rule works, see Budget Distribution Rules.
If you have a budget with entries assigned with Store No., it is also possible to consolidate these entries into generic entries not belonging to specific stores, by using the following function in Retail Sales Budget page:
- Consolidate Stores
- This will consolidate budget entries with Store No. into entries without stores, where the amount and quantity in the initial budget entries will be aggregated according to the same item group. This is useful for converting a budget intended for specific stores into a generic budget without stores. This action will automatically deactivate the Budget per Store setup and delete all assigned stores from the budget.
In order to use the breakdown and consolidate actions, you need a Setup permission to the budget, if the Setup Budget permission is not set to Anyone in the Replen. Setup. For more details see Budget Permissions.
Furthermore, the budget entries must first be in the correct format before they can be broken down or consolidated. The Check and Correct action (under Functions) in the Retail Sales Budget page can be used to validate and correct the budget entries. For more information on how this can be done, see How to: Check and Correct a Sales Budget.
To break down Sales Budgets to Days
- Click the
icon, enter Retail Sales Budget List, and select the relevant link. - Select the Retail Sales Budget you wish to break down, and click the Sales Budget action. The Retail Sales Budget page opens.
- Click Breakdown - Breakdown to Days.
Note: It is possible for the Breakdown to Days functionality to take into consideration the Retail Calendar or Base Calendar, where non-working days will be excluded from entries creation. This can be set up with the Consider Calendar field in the Replenishment FastTab on Retail Sales Budget page.
To break down Sales Budgets to Items
- Click the icon, enter Retail Sales Budget List, and select the relevant link.
- Select the Retail Sales Budget you wish to break down, and click the Sales Budget action. The Retail Sales Budget page opens.
- Click Breakdown - Breakdown to Items.
Note: Only items that are not blocked from purchasing or transferring will be considered for entries creation.
To break down Sales Budgets to Stores (Allocation Rule)
Note: Before breakdown to stores with Allocation Rule can be performed, it is important to ensure that an Allocation Rule has been assigned to the budget. This can be set up with the Allocation Rule Code field in the Replenishment FastTab in the Retail Sales Budget page.
- Click the icon, enter Retail Sales Budget List, and select the relevant link.
- Select the Retail Sales Budget you wish to breakdown, and click the Sales Budget action. The Retail Sales Budget page opens.
- Click Breakdown - Breakdown to Stores (Alloc. Rule). Once the breakdown is completed, the Budget per Store setup will be automatically activated, and all the relevant stores will also be added to the budget.
Example of how Breakdown to Stores (Allocation Rule) works:
An Allocation Rule is set up with four stores, and is assigned to a Retail Sales Budget for the use of Breakdown to Stores:
| Type | Code | Weight | % Share |
| Store | S0001 | 3.00 | 30.00 |
| Store | S0002 | 2.00 | 20.00 |
| Store | S0003 | 2.00 | 20.00 |
| Store | S0004 | 3.00 | 30.00 |
A budget entry without Store No. before breakdown:
| Entry No. | Store No. | Date | Item Category | Product Group | Quantity |
| 1 | 2020-01-01 | AUDIO | ACC | 100 |
With the assigned Allocation Rule, the budget entry will be broken down as follows:
| Entry No. | Store No. | Date | Item Category | Product Group | Quantity |
| 1 | S0001 | 2020-01-01 | AUDIO | ACC | 30 |
| 2 | S0002 | 2020-01-01 | AUDIO | ACC | 20 |
| 3 | S0003 | 2020-01-01 | AUDIO | ACC | 20 |
| 4 | S0004 | 2020-01-01 | AUDIO | ACC | 30 |
To break down Sales Budgets to Stores (Distribution)
Note: Before breakdown to stores with distribution rules can be performed, you must first activate the Budget per Store setup of the budget, and then select No when asked if you want to delete the existing budget entries without Store No.. The budget entries are intended to be broken down with the Store Distribution Rules in the next steps.
- Click the icon, enter Retail Sales Budget List, and select the relevant link.
- Select the Retail Sales Budget you wish to break down, and click the Sales Budget action. The Retail Sales Budget page opens.
- Add stores to the budget if you have not already done so, by using the Retail Sales Budget Stores page under Stores - Retail Budget Store.
- In the budget lines, assign a Store Distribution Rule to all the leaf-nodes in the budget, by using the Store Distribution field. For example, if the budget is of type Product Group, then all the Product Group nodes must be assigned with a Store Distribution Rule.
- Click Breakdown - Breakdown to Stores (Distrib.).
- For a distribution rule of type Equal or Proportional, the budget entries will be broken down evenly among the stores that have been assigned to the budget.
- For a Curve distribution rule, the budget entries will be broken down based on the weights and share % as per setup for each store. Any stores that exist in the distribution rule will also be automatically added to the budget.
For more information on how the Store Distribution Rule works, see Budget Distribution Rules.
To consolidate Stores in Sales Budgets
- Click the icon, enter Retail Sales Budget List, and select the relevant link.
- Select the Retail Sales Budget you wish to perform stores consolidation, and click the Sales Budget action. The Retail Sales Budget page opens.
- Click Breakdown - Consolidate Stores. Once the consolidation is completed, the Budget per Store setup will be automatically deactivated, and all the assigned stores will also be deleted from the budget.
Example of how Consolidate Stores works:
Before stores consolidation, the budget entries for Product Group ACC and SPEAKERS were assigned to store S0001 and S0002:
| Entry No. | Store No. | Date | Item Category | Product Group | Quantity |
| 1 | S0001 | 2020-01-01 | AUDIO | ACC | 70 |
| 2 | S0002 | 2020-01-01 | AUDIO | ACC | 30 |
| 3 | S0001 | 2020-01-01 | AUDIO | SPEAKERS | 40 |
| 4 | S0002 | 2020-01-01 | AUDIO | SPEAKERS | 20 |
After stores consolidation, the budget entries will look like this:
| Entry No. | Store No. | Date | Item Category | Product Group | Quantity |
| 1 | 2020-01-01 | AUDIO | ACC | 100 | |
| 2 | 2020-01-01 | AUDIO | SPEAKERS | 60 |